WebFOCUS query examples

Sample FOCUS query
 
TABLE FILE CAR
PRINT CAR MODEL SEATS
BY COUNTRY
END
Sample SQL query
 
SQL
SELECT COUNTY, CAR, MODEL, SEATS
FROM CAR
ORDER BY COUNTRY
END
Running a stored procedure (focexec)
 
EX GJDFEX2 COUNTRY='FRANCE'